INV Unit Of Measure Conversion Upload – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
INV Unit Of Measure Conversion Upload ============================= In R12.2 and later: This upload enables the user to
- upload new unit of measure conversions
- update existing unit of measure conversions.
The upload supports the following unit of measure conversion types:
- Standard, Intra-Class and Inter-Class, Lot Specific Inter-class
In R12.1: The functionality is restricted to creating new Item specific Intra-Class and Inter-Class conversions only. Update of existing unit of measure conversions is not supported in R12.1 Creation of Standard and Lot specific unit of measure conversions is not supported in R12.1
Report Parameters
Upload Mode, Conversion Type, From Unit of Measure Class, From Unit of Measure, To Unit of Measure Class, To Unit of Measure, Item, Lot Number
Oracle EBS Tables Used
mtl_uom_conversions, mtl_units_of_measure_vl, mtl_uom_classes_vl, mtl_system_items_vl, mtl_parameters, mtl_uom_class_conversions, mtl_lot_uom_class_conversions, uom_conv_qry
Report Categories
Related Reports
INV Item Upload, INV Items, CAC Manufacturing Variance, CAC Internal Order Shipment Margin, CAC WIP Resource Efficiency, INV Item Templates, CAC New Standard Item Costs, CAC Invoice Price Variance, INV Cycle count entries and adjustments
Running This SQL Without Blitz Report
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | None |
| Blitz Report™ XML Import | INV_Unit_Of_Measure_Conversion_Upload.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/inv-unit-of-measure-conversion-upload/ |
INV Unit Of Measure Conversion Upload - Case Study & Technical Analysis
Executive Summary
The INV Unit Of Measure Conversion Upload is a master data management tool. It allows for the bulk creation and update of UOM conversions (e.g., “1 Box = 10 Each”). This is essential for companies with complex packaging hierarchies or those that buy in one UOM and issue in another.
Business Challenge
Managing UOM conversions is complex and critical.
- New Product Introduction: Launching a new product line often requires defining dozens of conversions (Pallet -> Case -> Box -> Each).
- Supplier Changes: “The supplier changed the box size from 12 to 10. We need to update the conversion for 50 items.”
- Data Integrity: If a conversion is missing, the system cannot receive the goods, stopping the warehouse receiving dock.
Solution
The INV Unit Of Measure Conversion Upload streamlines the maintenance of these rules. It supports Standard, Intra-Class, and Inter-Class conversions.
Key Features:
- Bulk Creation: Define conversions for hundreds of items at once.
- Lot Specific: (R12.2+) Supports Lot-Specific conversions (e.g., “Lot A has a potency of 90%”, “Lot B has a potency of 95%”).
- Update Capability: Allows updating existing conversion rates (R12.2+).
Technical Architecture
The tool interacts with the UOM conversion tables, often using the INV_UOM_API or direct interface tables.
Key Tables and Views
MTL_UOM_CONVERSIONS: Standard and Inter-Class conversions.MTL_UOM_CLASS_CONVERSIONS: Intra-Class conversions.MTL_LOT_UOM_CLASS_CONVERSIONS: Lot-specific conversions.
Core Logic
- Upload: Reads the Item, From UOM, To UOM, and Rate from Excel.
- Validation: Checks that the UOMs exist and the item is valid.
- Processing: Calls the API to create or update the conversion record.
Business Impact
- Operational Continuity: Ensures that receiving and shipping processes are not blocked by missing master data.
- Accuracy: Reduces the risk of “fat finger” errors when defining critical conversion factors (e.g., entering 100 instead of 10).
- Efficiency: Saves hours of manual setup time during product launches.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics